Exploratory Water Analysis Report - Yampa River Valley 2022¶

Report created by A.J. Brown - Ansley.Brown@colostate.edu\ 6 September 2022\ Using Python 3.9.6\ Jupyter Lab 3.2.1\ Script Version 0.8

Introduction¶

The following script is a data report containing water quality data from samples taken in 2022 in the Yampa River Valley by the Colorado State University (CSU) Agriculture Water Quality Program (AWQP). For more information, please contact Erik Wardle at Erik.Wardle@colostate.edu or visit the CSU AWQP Website at https://waterquality.colostate.edu.

Table of contents¶

  1. Sample ID Legend
  2. Sample Location Map
  3. Interactive Graphics
    1. Boxplot
    2. Scatterplot
    3. Correlation Matrix of All Numerical Values
  4. Table of Raw Data

Sample ID Legend ¶

All samples were identified via "Sample ID" prefix using abbreviations corresponding to locations as noted in the legend below:

Sample ID Location
SB-SCI Stagecoach Inlet
SB-SCA Stagecoach Resevoir
SB-SCO Stagecoach Spillway
SB-TR Todd Ranch

Sample Location Map ¶

Use the interactive map below to look at samples taken. Hovering over points will show all parameters collected on site.

Make this Notebook Trusted to load map: File -> Trust Notebook

Interactive Graphics ¶

Boxplot ¶

Use the below boxplot to graph various water analytes stratified by sample type (i.e., Inflow, Outflow, etc.). Analytes can be selected by using the dropdown menu on the top left of the graph. Hover over points with your mouse for additional information.

Scatterplot ¶

Use the below Scatter plot to graph various water analytes against each other to see potential relationships. Analytes can be selected by using the dropdown menus near top left of the graph. Hover over points with your mouse for additional information.

Scatter Matrix of All Numerical Values ¶

Use the below scatter matrix to look at potential relationships between numerical variables.
Points are stratified by sample type (i.e., Inflow, Outflow, etc.). Hover over points with your mouse for additional information.

Table of Raw Data ¶

Location Date Irr./Storm Event Sample Type Replication ID Sample ID no2 TKN (mg/L) Total Phosphorus (mg/L) TSS (mg/L) Chlorophyll A (ug/L) Latitude Longitude notes Year hex
0 Yampa Valley 5/26/2022 Grab 1 SCI 1 SB-SCI-01-GB NaN NaN NaN 13.333333 30.65 40.285280 -106.846751 nitrite not tested for; no duplicate for chlor... 2022 #1f77b4
1 Yampa Valley 5/26/2022 Grab 1 SCI 2 SB-SCI-01-GB-D NaN NaN 0.110 6.666667 NaN 40.285280 -106.846751 nitrite not tested for; no duplicate for chlor... 2022 #1f77b4
2 Yampa Valley 5/26/2022 Grab 1 SCA 1 SB-SCA-01-GB NaN NaN 0.056 20.000000 7.37 40.268871 -106.883927 nitrite not tested for; no duplicate for chlor... 2022 #ff7f0e
3 Yampa Valley 5/26/2022 Grab 1 SCA 2 SB-SCA-01-GB-D NaN NaN 0.051 6.666667 NaN 40.268871 -106.883927 nitrite not tested for; no duplicate for chlor... 2022 #ff7f0e
4 Yampa Valley 5/26/2022 Grab 1 TR 1 SB-TR-01-GB NaN NaN NaN 0.000000 14.44 40.289025 -106.819500 nitrite not tested for; no duplicate for chlor... 2022 #2ca02c
5 Yampa Valley 5/26/2022 Grab 1 TR 2 SB-TR-01-GB-D NaN NaN 0.059 20.000000 NaN 40.289025 -106.819500 nitrite not tested for; no duplicate for chlor... 2022 #2ca02c
6 Yampa Valley 6/16/2022 Grab 1 SCO 1 SB-SCO-01-GB NaN 0.9 0.330 156.666667 NaN 40.285947 -106.829652 nitrite not tested for; ALS also tested TSS = ... 2022 #d62728
7 Yampa Valley 6/16/2022 Grab 1 SCO 2 SB-SCO-01-GB-D NaN 1.2 0.290 156.666667 NaN 40.285947 -106.829652 nitrite not tested for; ALS also tested TSS = ... 2022 #d62728
8 Yampa Valley 7/18/2022 Grab 2 SCI 1 SB-SCI-02-GB 0.81 NaN NaN 0.000000 NaN 40.285280 -106.846751 NaN 2022 #1f77b4
9 Yampa Valley 7/18/2022 Grab 2 SCI 2 SB-SCI-02-GB-D 0.82 NaN NaN 0.000000 NaN 40.285280 -106.846751 TSS was reported as -3.33, but is presented as... 2022 #1f77b4
10 Yampa Valley 7/18/2022 Grab 2 SCA 1 SB-SCA-02-GB 0.15 NaN 0.059 3.333333 NaN 40.268871 -106.883927 NaN 2022 #ff7f0e
11 Yampa Valley 7/18/2022 Grab 2 SCA 2 SB-SCA-02-GB-D 1.10 NaN 0.057 3.333333 NaN 40.268871 -106.883927 NaN 2022 #ff7f0e
12 Yampa Valley 7/13/2022 Grab 2 TR 1 SB-TR-02-GB 0.71 NaN NaN 16.666667 NaN 40.289025 -106.819500 formally mislabelled; correct ID is shown here 2022 #2ca02c
13 Yampa Valley 7/13/2022 Grab 2 TR 2 SB-TR-02-GB-D 0.71 NaN 0.057 3.333333 NaN 40.289025 -106.819500 formally mislabelled; correct ID is shown here 2022 #2ca02c